﻿CREATE TABLE [dbo].[PurchaseMaster] (
    [PurchaseNo]    VARCHAR (30)    NOT NULL,
    [VendorNo]      VARCHAR (8)     NOT NULL,
    [Dept]          INT             NULL,
    [ContractName]  VARCHAR (30)    NULL,
    [ContractNo]    VARCHAR (30)    NULL,
    [ReceivedWH]    INT             NULL,
    [Buyer]         VARCHAR (20)    NULL,
    [PayAccount]    VARCHAR (30)    NULL,
    [PayAmount]     NUMERIC (15, 2) NULL,
    [PayDate]       DATETIME        NULL,
    [InDate]        DATETIME        NULL,
    [EntryDate]     DATETIME        NULL,
    [EntryEmployee] VARCHAR (20)    NULL,
    [InvoiceNo]     VARCHAR (30)    NULL,
    [InvoiceDate]   DATETIME        NULL,
    [ReferenceNo]   VARCHAR (30)    NULL,
    [Remark]        VARCHAR (120)   NULL,
    [RecordID]      INT             IDENTITY (1, 1) NOT NULL
);

